|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Rider Change | |
| busseb 4/23/2014 8:07:06 PM | Tried to set up a UDM for rider change and found that if a rider has been on a horse 2-10 races back, this UDM won't flag it: SELECT * FROM STARTERHISTORY WHERE XTHSTARTRIDER = 1 AND STARTSLIFETIME > 1 Is there a field name like "riderlast" that compares only the current race rider to only the rider in the last race and not all previous races? ElPaso
| |
| jeff 4/24/2014 9:50:03 AM | Playlist File Mode: If you are operating the program in Playlist File Mode the following Preset Filter Codes enable flagging of jockey and/or trainer changes in your UDMs: BarnSwitch: BSWITCH=1 require barn switch today BSWITCH=0 avoid barn switch today BSWITCH=N avoid barn switch in record BSWITCH=Y require barn switch in record JockSwitch: JSWITCH=1 require jock switch today JSWITCH=0 avoid jock switch today JSWITCH=N avoid jock switch in record JSWITCH=Y require jock switch in record Q. What's a barn switch? A. In JCapper a barn switch is tied to a change in trainer name(s). A horse is said to be making a barn switch today if the trainer listed for today's start is different than the trainer listed for the horse's previous start. Q. What's a jock switch? A. In JCapper a jock switch is tied to a change in rider name(s). A horse is said to be making a jock switch today if the rider listed for today's start is different than the rider listed for the horse's previous start. These new preset filters can provide some interesting results when combined with other factors - including the XthStart for both rider and trainer filters. Hint: Some trainers are actually pretty good when a horse they've had in the past (and lost to someone else) ends up back in their barn again. SQL Mode: If you are operating the program inSQL Mode (unfortunately) the closest you can get is XthStartRider and/or XthStartTrainer - which as you mentioned - is not the same thing as a rider or trainer switch. -jp .
| |
| busseb 4/24/2014 3:09:37 PM | Same for trainer changes?
| |
| jeff 4/26/2014 10:59:20 AM | Yup. The same. -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |